HeightAdjustmentAspose.java

package xlsx4j.workingwithworksheet;

import com.aspose.cells.Cells;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;

/**
 * @author Shoaib Khan
 */
public class HeightAdjustmentAspose
{
	public static void main(String[] args) throws Exception
	{
		//Instantiating a Workbook object
		Workbook workbook = new Workbook();

		//Accessing the first worksheet in the Excel file
		Worksheet worksheet = workbook.getWorksheets().get(0);
		Cells cells = worksheet.getCells();

		//Setting the height of all rows in the worksheet to 8
		worksheet.getCells().setStandardHeight(8f);
		
		//Setting the height of the second row to 40
		cells.setRowHeight(1, 40);

		//Saving the modified Excel file in default (that is Excel 2003) format
		workbook.save(System.getProperty("user.dir") + "/data/xlsx4j/RowHeight-Aspose.xlsx");
		
		//Print Message
	    System.out.println("Worksheet saved successfully.");
	}
}